Optimization of Database Capability in the E-governmental Spatial Aided Decision-making System

E-governmental Spatial Aided Decision-making System based on GIS and DSS is a representative paradigm in the fields of egovernment application.Oracle9i database is adopted is an important aspect of system application. It is a big and complicated run database system whose run efficiency is of great importance to system capability. There are lots of methods of optimization for oracle9i database. This paper proposed some optimizational principles and methods of oracle9i database capability in the aspects of database structure, SQL Sentence and memory assignation, etc. And the system capability has been enhanced to comparatively great extent by using these above-mentioned methods of optimizing database during the course of system application. At last, this paper gave some integrated and further conclusion about optimization of oracle9i database.